关键词: Excel, VBA, 标准化试卷, 自动判卷

Abstract: In the daily teaching process, many kinds of tests and examinations are indispensable, so grading efficiently is important for reducing teacher’s workload. Professional paperless examination system not only needs invest more resources, but also not suits our own all teaching needs. Based on the need of general grading standardized paper and using Excel features of data processing, data management and data security etc, this paper designs standardized paperless examination template. And using Excel as a development platform, automatic grading system of standard examination paper is implemented by VBA langue. Automatic grading system not only improves teachers’ work efficiency, but also reduces the workload of teachers obviously. As the system is simple, safe and efficient, there are important practical values in teaching applications.

Key words: Excel, VBA, standardized examination papers, automatic grading